Tabela StockItemQuota

Definicja tabeli StockItemQuota

Name

StockItemQuota

Code

StockItemQuota

Comment

Tabela do obslugi stanów minimalnych/maksymalnych danego zasobu.



Lista kolumn tabeli StockItemQuota

Name

Code

StockItemQuotaID

StockItemQuotaID

StockID

StockID

StockItemID

StockItemID

PackageID

PackageID

MinQuantity

MinQuantity

MaxQuantity

MaxQuantity

OptimalQuantity

OptimalQuantity

StartDT

StartDT

StopDT

StopDT

Active

Active

InsertingPerson

InsertingPerson

InsertDT

InsertDT

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT


Kolumna StockItemQuotaID tabeli StockItemQuota

Definicja kolumny StockItemQuotaID tabeli StockItemQuota

Name

StockItemQuotaID

Code

StockItemQuotaID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockID tabeli StockItemQuota

Definicja kolumny StockID tabeli StockItemQuota

Name

StockID

Code

StockID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StockItemID tabeli StockItemQuota

Definicja kolumny StockItemID tabeli StockItemQuota

Name

StockItemID

Code

StockItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID asortymentu


Kolumna PackageID tabeli StockItemQuota

Definicja kolumny PackageID tabeli StockItemQuota

Name

PackageID

Code

PackageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MinQuantity tabeli StockItemQuota

Definicja kolumny MinQuantity tabeli StockItemQuota

Name

MinQuantity

Code

MinQuantity

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Minimalna ilosc zasobu na magazynie


Kolumna MaxQuantity tabeli StockItemQuota

Definicja kolumny MaxQuantity tabeli StockItemQuota

Name

MaxQuantity

Code

MaxQuantity

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Maksymalna ilosc zasobu na mag.


Kolumna OptimalQuantity tabeli StockItemQuota

Definicja kolumny OptimalQuantity tabeli StockItemQuota

Name

OptimalQuantity

Code

OptimalQuantity

Data Type

NUMBER(12,4)

Mandatory

No

Comment

Ilosc optymalna (taka powinna zawsze byc dostepna) zasobów w magazynie


Kolumna StartDT tabeli StockItemQuota

Definicja kolumny StartDT tabeli StockItemQuota

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Poczatek obowiazywania limitu


Kolumna StopDT tabeli StockItemQuota

Definicja kolumny StopDT tabeli StockItemQuota

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Koniec obowiazywania limitu


Kolumna Active tabeli StockItemQuota

Definicja kolumny Active tabeli StockItemQuota

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InsertingPerson tabeli StockItemQuota

Definicja kolumny InsertingPerson tabeli StockItemQuota

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsertDT tabeli StockItemQuota

Definicja kolumny InsertDT tabeli StockItemQuota

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna LastModifiedPerson tabeli StockItemQuota

Definicja kolumny LastModifiedPerson tabeli StockItemQuota

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli StockItemQuota

Definicja kolumny LastModifiedDT tabeli StockItemQuota

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Lista kluczy tabeli StockItemQuota

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli StockItemQuota

Definicja klucza Identifier_1 tabeli StockItemQuota

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment